Tabela AdmCodeText

Definicja tabeli AdmCodeText

Name

AdmCodeText

Code

AdmCodeText

Comment

PL: Tabela opisowa dla kodów administracyjnych
EN: Descriptive table for administration code
DE: Die descriptive Tabelle den administrativen Code


Lista kolumn tabeli AdmCodeText

Name

Code

LanguageID

LanguageID

AdmCodeID

AdmCodeID

RegionTypeID

RegionTypeID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

AlternativeCode

AlternativeCode


Kolumna LanguageID tabeli AdmCodeText

Definicja kolumny LanguageID tabeli AdmCodeText

Name

LanguageID

Code

LanguageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmCodeID tabeli AdmCodeText

Definicja kolumny AdmCodeID tabeli AdmCodeText

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna RegionTypeID tabeli AdmCodeText

Definicja kolumny RegionTypeID tabeli AdmCodeText

Name

RegionTypeID

Code

RegionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu regionu


Kolumna Code tabeli AdmCodeText

Definicja kolumny Code tabeli AdmCodeText

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli AdmCodeText

Definicja kolumny ShortName tabeli AdmCodeText

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli AdmCodeText

Definicja kolumny FullName tabeli AdmCodeText

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli AdmCodeText

Definicja kolumny Description tabeli AdmCodeText

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna AlternativeCode tabeli AdmCodeText

Definicja kolumny AlternativeCode tabeli AdmCodeText

Name

AlternativeCode

Code

AlternativeCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Rosyjskie kody okato


Lista kluczy tabeli AdmCodeText

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AdmCodeText

Definicja klucza Identifier_1 tabeli AdmCodeText

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment